Append Row

Description

Google Spreadsheet: Append Spreadsheet Plugin Step appends rows to a spreadsheet on Google Drive.

Configurations

No.	Field Name	Description
1	Step name	Name of the step as it appears in the workflow workspace. This name has to be unique in a single workflow.
	Connection:	Refer Prerequisites and References above to get the connection attributes.
2	Client ID	Specify Client ID of the Google application. The data type is String. This field is mandatory.
	Client Secret:
3	Accept Values from fields	Leave checkbox unchecked to accept Client Secret value from a field in the previous steps of the stream using a drop down list. Else enable checkbox for Secret Key field to appear as Text box.
4	Client Secret	Specify Client Secret of the Google application. Client Secret is entered using a widget. If checkbox above is enabled Client Secret field appears as Text box and accepts static values or variables. Else if checkbox above is disabled Client Secret field appears as a drop down containing values from previous steps - to select from. The data type is String. This field is mandatory.
	Refresh Token:
5	Accept Values from fields	Leave checkbox unchecked to accept Secret Key value from a field in the previous steps of the stream using a drop down list. Else enable checkbox for Secret Key field to appear as Text box.
6	Refresh Token	Specify a Refresh Token to obtain a new Access Token. Note: Refresh Token expires if idle for 6 months. Refresh Token is entered using a widget. If checkbox above is enabled Refresh Token field appears as Text box and accepts static values or variables. Else if checkbox above is disabled Refresh Token field appears as a drop down containing values from previous steps - to select from. The data type is String. This field is mandatory.
7	Button: Test Connection	Verifies whether the connection is established or not. Note: For the purpose of verification fields coming from previous steps are not allowed since field values can only be accessed when workflow is in running state; only static values and environment variables are allowed.
	Input Fields:
1	Spreadsheet ID	Specify the unique ID allocated to the spreadsheet. This ID is the value between the "/d/" and the "/edit" in the URL of your spreadsheet. For example, Spreadsheet ID reference URL - For example, consider the following URL that references a Google Sheets spreadsheet: https://docs.google.com/spreadsheets/d/1CJnkal5pj3SLpv-HdmyguX/edit#gid=0 Then, Spreadsheet ID is: 1CJnkal5pj3SLpv- HdmyguX as highlighted above.
2	Sheet Name	The unique name of the sheet such as Sheet1, Sheet2 likewise.
	Button: Get Fields	Click this button to fetch the field values from previous steps.
1	Table Fields:
	Name	Specify the field Names (or Columns) for the rows you wish to append. Names are populated by clicking the Get Fields button above from previous steps in the workflow stream. You may keep all field Names populated or remove some field names for the rows you wish to append to this sheet. There are other scenarios while working with this step. You may use the Get Fields button above to fetch field Names. You may click on this button again for any reasons such as new fields in the workflow stream etc. In such a case if data is already present in the step a pop-up window is displayed with four options as seen in the snapshot below. You may choose to add only new rows, Add all rows again, Clear existing rows and add all rows or cancel Get Fields button.
2	Type	The data Type of field Names above. Type values are only for user information purposes on plugin window. Note: At least one combination of Name and Type should be provided.